<?php
class ModelCatalogQa extends Model {
	public function addQa($product_id, $data) {
		$this->db->query ( "INSERT INTO " . DB_PREFIX . "qa SET author = '" . $this->db->escape ( $data ['name'] ) . "', customer_id = '" . ( int ) $this->customer->getId () . "', product_id = '" . ( int ) $product_id . "', text = '" . $this->db->escape ( $data ['text'] ) . "', date_added = NOW()" );
	}
	
	public function getQasByProductId($product_id, $start = 0, $limit = 20) {
		$query = $this->db->query ( "SELECT r.qa_id, r.author,r.answer, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM " . DB_PREFIX . "qa r LEFT JOIN " . DB_PREFIX . "product p ON (r.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '" . ( int ) $product_id . "' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '" . ( int ) $this->config->get ( 'config_language_id' ) . "' ORDER BY r.date_added DESC LIMIT " . ( int ) $start . "," . ( int ) $limit );
		
		return $query->rows;
	}
	
	public function getTotalQas() {
		$query = $this->db->query ( "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "qa r LEFT JOIN " . DB_PREFIX . "product p ON (r.product_id = p.product_id) WHERE p.date_available <= NOW() AND p.status = '1' AND r.status = '1'" );
		
		return $query->row ['total'];
	}
	
	public function getTotalQasByProductId($product_id) {
		$query = $this->db->query ( "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "qa r LEFT JOIN " . DB_PREFIX . "product p ON (r.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '" . ( int ) $product_id . "' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '" . ( int ) $this->config->get ( 'config_language_id' ) . "'" );
		
		return $query->row ['total'];
	}
}
?>